Often, you will require data from more than one iMIS table for export. For example, you may need FULL_NAME and COMPANY from the Name table and TYPE=‘DUES’ and BALANCE from the Subscription table. Since there is no membership data in the Subscription table, you must access the Name table. To use data from two or more tables, you must join them.
To join files (tables) is to specify which fields are equivalent so the files can relate to each other correctly, record by record. In effect, joining glues the files together for the export process. The most common joins in iMIS center on member ID numbers. A join across three tables might be:
Name.ID = Activity.ID
Name.ID = Subscription.ID